﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using DLV.Utilities;

namespace DLV.Data.Entities
{
    public class TravelGuidePriceController
    {
        public int InsertTravelGuidePrice(TravelGuidePriceInfo info)
        {
            return SQL.InsertTravelGuidePrice(info.TravelGuidePriceName, info.Level, info.LanguageId, info.ScheduleId, info.Price, info.CreatedBy, info.CreatedDate, info.UpdatedBy, info.UpdatedDate, info.Status, info.ExtraMoney);
        }
        public void UpdateTravelGuidePrice(TravelGuidePriceInfo info)
        {
            SQL.UpdateTravelGuidePrice(info.TravelGuidePriceId, info.TravelGuidePriceName, info.Level, info.LanguageId, info.ScheduleId, info.Price, info.CreatedBy, info.CreatedDate, info.UpdatedBy, info.UpdatedDate, info.Status, info.ExtraMoney);
        }
        public void DeleteTravelGuidePrice(TravelGuidePriceInfo info)
        {
            DeleteTravelGuidePrice(info.TravelGuidePriceId);
        }
        public void DeleteTravelGuidePrice(int travelGuidePriceId)
        {
            SQL.DeleteTravelGuidePrice(travelGuidePriceId);
        }
        public TravelGuidePriceInfo GetTravelGuidePrice(int travelGuidePriceId)
        {
            return CBO.FillObject<TravelGuidePriceInfo>(SQL.GetTravelGuidePrice(travelGuidePriceId));
        }
        public List<TravelGuidePriceInfo> ListTravelGuidePrice()
        {
            return CBO.FillCollection<TravelGuidePriceInfo>(SQL.ListTravelGuidePrice());
        }
        public DataTable SelectTravelGuidePrice()
        {
            return CBO.ConvertToDataTable(ListTravelGuidePrice(), typeof(TravelGuidePriceInfo));
        }
        public List<TravelGuidePriceInfo> ListTravelGuidePriceByTravelGuide(int travelGuideId)
        {
            return CBO.FillCollection<TravelGuidePriceInfo>(SQL.ListTravelGuidePriceByTravelGuide(travelGuideId));
        }
    }
}
